﻿using System;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace Gl_mes.DAL.MesDB
{
    /// <summary>
    /// 员工调进调出明线表
    /// </summary>
    [Table("empl_lend")]
    public class EmplLend
    {
        /// <summary>
        /// ID，主键，自增长
        /// </summary>
        [Column("id"), Key, DatabaseGenerated(DatabaseGeneratedOption.Identity)]
        public int ID { get; set; }

        /// <summary>
        /// 员工ID
        /// </summary>
        [Column("empl_id")]
        public int EmplID { get; set; }

        /// <summary>
        /// 员工工号
        /// </summary>
        [Column("empl_number")]
        public string EmplNumber { get; set; }

        /// <summary>
        /// 员工姓名
        /// </summary>
        [Column("empl_name")]
        public string EmplName { get; set; }

        /// <summary>
        /// 考勤日期
        /// </summary>
        [Column("att_date")]
        public DateTime AttDate { get; set; }

        /// <summary>
        /// 借出生产线ID
        /// </summary>
        [Column("lend_line_id")]
        public int LendLineID { get; set; }

        /// <summary>
        /// 借出生产线名
        /// </summary>
        [Column("lend_line_name")]
        public string LendLineName { get; set; }


        /// <summary>
        /// 借入生产线ID
        /// </summary>
        [Column("borrow_line_id")]
        public int BorrowLineID { get; set; }

        /// <summary>
        /// 借入生产线名
        /// </summary>
        [Column("borrow_line_name")]
        public string BorrowLineName { get; set; }


        /// <summary>
        /// 开始时间
        /// </summary>
        [Column("begin_time")]
        public DateTime? BeginTime { get; set; }

        /// <summary>
        /// 结束日期
        /// </summary>
        [Column("end_time")]
        public DateTime? EndTime { get; set;}

        /// <summary>
        /// 借调总用时（以分钟计算）
        /// </summary>
        [Column("att_time")]
        public decimal? AttTime { get; set; }

        /// <summary>
        /// 备注
        /// </summary>
        [Column("remark")]
        public string Remark { get; set; }

        /// <summary>
        /// 是否已审核，1代表已审，0代表未审
        /// </summary>
        [Column("is_confirm")]
        public int IsConfirm { get; set; }

        /// <summary>
        /// 审核人
        /// </summary>
        [Column("confirm_user")]
        public string ConfirmUser { get; set; }

        /// <summary>
        /// 审核日期
        /// </summary>
        [Column("confirm_date")]
        public DateTime? ConfirmDate { get; set; }

        /// <summary>
        /// 建档日期
        /// </summary>
        [Column("create_user")]
        public string CreateUser { get; set; }

        /// <summary>
        /// 建档人
        /// </summary>
        [Column("create_date")]
        public DateTime CreateDate { get; set; }

        /// <summary>
        /// 更新人
        /// </summary>
        [Column("update_user")]
        public string UpdateUser { get; set; }

        /// <summary>
        /// 更新日期
        /// </summary>
        [Column("update_date")]
        public DateTime? UpdateDate { get; set; }
    }
}
